Stored Procedures [dbo].[sp_asi_GetCompanySort]
SQLServer > iMIS1521GA > Stored Procedures > dbo.sp_asi_GetCompanySort
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)Direction
@CompanyNamevarchar(80)80
@CompanySortvarchar(30)30Out
Permissions
TypeActionOwning Principal
GrantExecuteIMIS
SQL Script
/****** Object:  StoredProcedure dbo.sp_asi_GetCompanySort  ******/

CREATE PROCEDURE dbo.sp_asi_GetCompanySort
    @CompanyName varchar(80),
    @CompanySort varchar(30) OUTPUT
AS
BEGIN
    SET NOCOUNT ON

    SET @CompanySort = dbo.fn_asi_GetCompanySort(@CompanyName)
    SELECT @CompanySort as CompanySort
END

GO
GRANT EXECUTE ON  [dbo].[sp_asi_GetCompanySort] TO [IMIS]
GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved